Version 10-01-84
%H0HELP MENU    
================================================================
Press a NUMBER for information on the following subjects:

    1 - Using the Main Menu     4 - Entering text        
    2 - Moving the cursor       5 - Entering numbers 
    3 - Entering data           6 - Entering formulas      
        (overview)              7 - Giving commands        
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Press a LETTER for information on the following commands: (For 
the same information from a worksheet, press a slash (/), the 
letter, and F1.)

/B - Blank (erase) row/column  /P - Print
/C - Calculate                 /R - Replicate (copy) row/column
/D - Delete row/column         /T - Title locking
/F - Format one cell/row/col.  /U - Update timing of auto save 
/G - Global format/col width   /W - Windows
/I - Insert row/column         /X - eXit from program 
/J - Jump to cell              /Z - Zap (erase) one cell/row/
/M - Move row/column                column/worksheet
/O - Output to disk            

              (Press ESCAPE to return to worksheet)
%H1USING THE MAIN MENU     

  Edit Worksheet - To edit an existing worksheet stored on the data disk.

  Create Worksheet - To create a new worksheet.

  Delete Worksheet - To erase an existing worksheet from the data disk.

  Worksheet to Transfer Format - To prepare a worksheet for making it
                                 larger or smaller or to be merged into
                                 another worksheet.

  Transfer Format to Worksheet Format - The second step to change the 
                                        size of a worksheet.

  Merge from Transfer Format - To merge data from a worksheet prepared by
                               the Worksheet to Transfer Format command.

  Change Data Drive - To tell Number Works which drive your data disk is in.

  Exit Number Works - To leave Number Works and return to your computer's
                      operating system. 

            (Press ESCAPE to return to the Help Menu)
%H2MOVING THE CURSOR

To determine the exact location (row and column) of the cursor, 
look at the left of the status line at the top of your screen. 

Use these keys to move the cursor across the worksheet:

    Left one column - Press left arrow
    Right one column - Press right arrow
    
    Up one line - Press up arrow
    Down one line - Press down arrow
    
    To edge of screen - Press END plus any arrow key
    
    To next window - Press TAB

To move the cursor to a specific cell, use the JUMP (/J) command.  
To find out more about this command, press J at the Help Menu, 
or press /J and then F1 while editing a worksheet. 


            (Press ESCAPE to return to the Help Menu)
%H3ENTERING DATA (OVERVIEW)     

There are three types of data you can enter on your worksheet:

     o  Text         o  Numbers        o  Formulas

To find out more about each of these, press ESCAPE to return to 
the Help Menu. Then press the appropriate key from the menu's 
selection. 

All data is entered into the "active" cell.  This is the cell 
where the lightbar cursor appears.  You can also see the active 
cell's location by the row and column numbers at the top left of 
the status line at the top of your screen.  

As you type the data for your entry, you'll see it appear near 
the top left of your screen between the status line and the 
worksheet. When you press ENTER, the data is automatically 
entered into the active cell. (Press an arrow key instead of 
ENTER to have the data entered and the cursor move in the 
direction of the arrow.)

           (Press ESCAPE to return to the Help Menu.)
%H4ENTERING TEXT         

REGULAR - Text is usually used for row names or column headings.  
Enter text by first typing an apostrophe (') followed by any characters
you want as text.  (The apostrophe won't appear on your worksheet;
it simply tells Number Works that the characters following it are a
text entry.)  Text longer than the width of the cell will extend 
into successive cells if they are empty.

REPEATING - Repeating text is usually used to "decorate" a worksheet,
for example, making rows of asterisks ********** or dashes ----------.
Create repeating text by pressing the quote key ("), and then the 
character(s) you want to repeat.

When entering text, press the BACKSPACE key (located above the ENTER
key) to erase the previous character or ESCAPE to erase the entire entry.

Press F2 while entering text to activate Edit Mode.  While in Edit
Mode the LEFT and RIGHT arrow keys move the cursor over your text and
the HOME and END keys move it to either end of the line.  To leave Edit
Mode, press the ENTER key, or press ESCAPE to cancel the entry.

           (Press ESCAPE to return to the Help Menu.)
%H5ENTERING NUMBERS

Use the number keys at the top of the keyboard to enter all 
numbers into your worksheet.  (If you press the NumLock key to
use the 10-key pad you must press NumLock again to reactivate
the arrow keys.)

Enter any numbers you wish, positive or negative, with or without 
decimal points.  Enter negative numbers starting with the minus 
sign: -23.5.

Numbers can be displayed on your worksheet in various formats.  
Use the /G - Global or /F - Format commands to specify how you 
want the numbers displayed. 

Press F2 while entering numbers to activate Edit Mode.  While in Edit
Mode the LEFT and RIGHT arrow keys move the cursor over your value and
the HOME and END keys move it to either end of the line.  To leave Edit
Mode, press the ENTER key, or press ESCAPE to cancel the entry.
           (Press ESCAPE to return to the Help Menu.)
%H6ENTERING FORMULAS

Formulas are numbers or mathematical statements that Number 
Works uses to make calculations.  Formulas can include addition 
(+), subtraction (-), multiplication (*), division (/), and 
exponentiation (^).  

Number Works calculates from left to right.  For example, the
result of 1+2/3 is 1, not 1.666667.  Portions of formulas within
parentheses are calculated first, but also from left to right.
To reference a cell in a formula, use the format RxCx. (R1C1
means Row 1, Column 1.)  For example, R2C9+R7C3/ABS(R2C2).

Number Works has these built-in formulas:

ABS      AVE      EXP      ISERR     LOOKUP    NE      SIN
ACOS     COS      GE       ISNA      LT        NOT     SGN
AND      COUNT    GT       LE        MAX       NPV     SQRT
ASIN     EQ       IF       LN        MIN       OR      SUM
ATAN     ERROR    INT      LOG       NA        PI      TAN

For more information, see Chapter 7 of your instruction book.

           (Press ESCAPE to return to the Help Menu.)
%H7GIVING COMMANDS        

To give a command to Number Works, at the worksheet type a slash 
(/) followed by the letter of the command.  For example, /J for 
the Jump command.  Press ESCAPE at any time to cancel a command.

After giving a command, you'll see a series of prompts below the 
status line.  A cursor shows where you need to enter information.  
If you want helpful information about the command, press function 
key F1 after giving the command. 

Fill in all requested information so Number Works can carry out 
your command exactly as you want.  Sometimes a pre-set entry 
already appears. Press ENTER if this is satisfactory.  If not, 
make a new entry and press ENTER. The cursor will occasionally 
pass by a prompt depending on how you've answered previous 
prompts. Press ESCAPE to return to the first prompt.

            (Press ESCAPE to return to the Help Menu)

%B0HELP FOR /B - BLANK COMMAND

Use this command to blank (erase) all data in the row or column 
where the cursor is located.  The format remains. (Use the /Z - 
Zap command to remove the format, too.) 

Number Works automatically makes any necessary recalculations 
after it completes this command.

           (Press ESCAPE to return to previous screen)
%C0HELP FOR /C - CALCULATION COMMAND

Use the /C - Calculation command to change the way Number Works 
does calculations. The current way is shown by the three letters 
on the status line - (R)ows, (M)anual, (F)ull, for example. 

"By Rows or Columns" asks if you want the calculation done row-by-
row or column-by-column. The calculation is faster if you choose 
the smaller dimension.    

"Manual or Automatic":  Choose A for automatic recalculation, or 
M for recalculation only when you press the equal key (=).  It's
best to select manual recalculation when you have many numbers
or formulas to enter.

"Full or Partial": Do you want the (F)ull or (P)artial worksheet 
recalculated?  If you type P, Number Works asks for the limits of 
the section to recalculate.  

           (Press ESCAPE to return to previous screen) 
%D0HELP FOR /D - DELETE COMMAND

Use this command to delete the row or column (not just the data) 
where the cursor is located.  All other rows or columns then move 
in to fill the gap.  The last row or column becomes blank.  

Number Works automatically adjusts all row and column references, 
and makes any necessary recalculations.

           (Press ESCAPE to return to previous screen)
%F0HELP FOR /F - FORMAT COMMAND

Use this command to change the format for the cell, row, column, 
or window where the cursor is currently located.  You can change
the way numbers are displayed, and how text is justified.

Each cell can have its own format.  If you don't specify a 
particular format, Number Works uses the standard worksheet 
format set by the /G-Global command. 

If you select E or F for the format, Number Works asks how many 
digits you want displayed after the decimal point. 

The screen is updated as the program changes the individual 
formats.  Asterisks (*) appear in any cell where the current 
format can't be used. 

           (Press ESCAPE to return to previous screen)
%G0HELP FOR /G - GLOBAL COMMAND

Use this command to specify for the entire worksheet:  1) The
width of the worksheet columns; 2) How numbers are displayed;
and 3) Whether text is right or left-justified.

The global format is the one used throughout the worksheet when 
nothing else is specified. (Use /F-Format to change the format of 
a specific area of the worksheet.  When you change the global 
format, you don't affect those areas that have been formatted 
with /F).

FORMATS: E - Exponential  G - General  I - Integer  $ - Dollar
         F - Fixed        H - Hide     R - Right-justified  

If you choose E or F format, Number Works asks how many digits 
you want displayed after the decimal point. If you change column 
width, Number Works asks if you want all text adjusted to prevent
the new width from causing spaces within text.

           (Press ESCAPE to return to previous screen)
%I0HELP FOR /I - INSERT COMMAND

Use this command to insert a blank row or column where the cursor 
is located.  All other rows or columns move to create the 
necessary space. 

CAUTION:  If data is "pushed off the edge" of your worksheet when 
you insert a row or column, that data cannot be retrieved. 

The new row or column will use the current global format.  Number 
Works automatically adjusts all cell references, and makes any 
necessary recalculations.

           (Press ESCAPE to return to previous screen)
%J0HELP FOR /J - JUMP COMMAND

Use this command to jump (instantly move) the cursor to any 
specific cell on your worksheet.  If that cell isn't currently 
displayed, Number Works will shift the worksheet until it is. 

Enter the coordinates (row and column numbers) of the cell where 
you want the cursor to jump to, and press ENTER.

If the row or column number you want is already displayed in the 
brackets, just press ENTER.  If you enter a number with fewer 
digits than the number in brackets, press SPACEBAR to erase the 
rest of the old number.
              
           (Press ESCAPE to return to previous screen)
%M0HELP FOR /M - MOVE COMMAND

Use this command to move the data in the row or column where the 
cursor is currently located to another row or column on the 
worksheet.  All other row or column data on the worksheet moves 
as necessary. 

Number Works automatically adjusts all cell references, and makes 
any necessary recalculations.

REMEMBER: You're moving data, not copying it. The data is deleted 
from its original location and moved to a new one.  If you simply 
want to copy data to another location, use the /R - Replicate 
command.

           (Press ESCAPE to return to previous screen)
%O0HELP FOR /O - OUTPUT TO DISK COMMAND

Use this command to store your worksheet on disk in a format 
which can be read by most word processors. 

You can output the worksheet in either of two formats:

    * The way it looks on SCREEN (with or without row and column 
      numbers).  If you to store less than a full screen, first
      use the /W - Windows command to set up the row and column 
      dimensions of the area you want to store.

    * As a LIST of its contents - Each line of the list contains
      cell location, data type, and contents (except cells which
      contain text).

           (Press ESCAPE to return to previous screen)
%P0HELP FOR /P - PRINT COMMAND

Use this command to print your worksheet in either of two ways:

    * The way it looks on SCREEN (with or without row and column 
      numbers).  If you want to print less than a full screen,
      first use the /W - Windows command to set up the row and
      column dimensions of the area you want to print. Then enter
      the number of columns you want the printed page width to be. 

    * As a LIST of its contents - Each line of the list contains 
      cell location, data type, and contents (except cells which
      contain text.)

If your worksheet is wider than your printer, you'll have to 
print the worksheet one window at a time.  

Press the SPACEBAR at any time to stop printing, and again to 
resume printing. 

           (Press ESCAPE to return to previous screen)
%R0HELP FOR /R - REPLICATE COMMAND

Use this command to copy full or partial data in a row or column 
to another location on the worksheet.  The original remains 
where it is.  

"Source" is where the cursor is currently located.  If it's in 
row (or column) 1, Number Works asks for number of entries.  
Enter the number of cells you want moved. 

"Destination" is where you first want the data to be copied.                   
"Number of times" asks in how many consecutive rows or columns 
(including the destination) you want the data copied. 

Specify which row and column references you want adjusted. Number 
Works automatically makes any necessary recalculations. 

           (Press ESCAPE to return to previous screen)
%T0HELP FOR /T - TITLE COMMAND

  Use this command to "lock" titles (column headings, row names) 
so they stay in place when the worksheet moves. Usually the first 
few columns or rows contain titles describing the data on your 
worksheet.  During normal scrolling, these titles are pushed off 
the screen.  /T keeps them on the screen.

You have these choices:

   H (Horizontal) - Lock all rows above the cursor
   V (Vertical)   - Lock all columns to the left of the cursor
   B (Both)       - Lock rows and columns
   C (Clear)      - Unlock current settings

           (Press ESCAPE to return to previous screen)
%U0HELP FOR /U - UPDATE COMMAND

Use this command to change how often Number Works automatically 
saves your worksheet to disk. Number Works does this to protect 
your data in case the power should fail.

Initially, Number Works saves your worksheet whenever 60 seconds
have passed since you last pressed a key.  No update will occur if
you have not changed any worksheet data since the last update.

The Update command lets you change the number of seconds that must
pass before an automatic update will occur.

Note that presing any key will interrupt an automatic update.

           (Press ESCAPE to return to previous screen)
%W0HELP FOR /W - WINDOW COMMAND

Use this command to create (or clear) windows. A window is a 
area through which you "view" a portion of your worksheet.  You 
can create up to eight windows, each with its own format and 
titles.  Windows can be horizontal (arranged by rows) or vertical 
(arranged by columns).  Use these windows for split screen 
viewing or for printing only parts of a worksheet.

Use this command also to specify synchronized scrolling (all 
windows move simultaneously) or unsynchronized scrolling (each 
window moves independently.)

Number Works initially asks for the number of rows and columns 
for the first window; then for the number of rows (for 
horizontal) or columns (for vertical) for each additional window. 
To move the cursor from one window to the next, press the TAB 
key.              

           (Press ESCAPE to return to previous screen)
%X0HELP FOR /X - EXIT COMMAND

Use this command to leave the worksheet and go back to the Master 
Menu.  From there you can choose another option or leave the 
program. 

When you use this command, all data currently in your computer's 
memory is automatically saved on disk, except for window and 
title settings. 

           (Press ESCAPE to return to previous screen)
%Z0HELP FOR /Z - ZAP COMMAND

Use this command to zap (erase) data in the cell, row, or column 
where the cursor is located, or to erase the entire worksheet.  
(If you Zap the entire worksheet, all windows are removed.)  This 
command also removes the current format of the area "zapped". 
(Use the /B-Blank command if you want to erase the data but keep 
the format). 

After this command is completed, Number Works automatically makes 
any necessary recalculations. 

           (Press ESCAPE to return to previous screen)
%XX
~

  
